
# apply these models to the application
from google.appengine.ext import db

### Static model
class UserInfo(db.Expando):
    userID=db.StringProperty()          # mixi ID
    totalUseTime=db.IntegerProperty()   # total use time of word
    lastPlayedDate=db.DateTimeProperty()
    recentUseWordKeys=db.StringListProperty()

class UserFavoriteList(db.Expando):
    userID=db.StringProperty()
    favoriteList=db.StringListProperty()
  
class ItemInfo(db.Expando):
    lCategoryID=db.IntegerProperty()     # large category
    mCategoryID=db.IntegerProperty()     # middle category
    itemID=db.IntegerProperty()          # itemID
    selectedTime=db.IntegerProperty()   # used time
    selectedDate=db.DateTimeProperty()  # used date
    selectedDateInt = db.IntegerProperty() #used date by second
    addedDate=db.DateTimeProperty()     # item added time
    itemValue=db.StringProperty()       # faceword
    fullItemID=db.StringProperty()
 
'''    
class History(db.Expando):
    userID=db.StringProperty()          # mixi ID
    lCategoryID=db.IntegerProperty()     # large category
    mCategoryID=db.IntegerProperty()     # middle category
    itemID=db.IntegerProperty()          # itemID
    selectedTime=db.IntegerProperty()   # used time
    selectedDate=db.DateTimeProperty()  # used date
    isFavorite=db.BooleanProperty()      # boolean 
'''
    
class Category(db.Expando):
    lCategoryID=db.IntegerProperty()     # large category
    mCategoryID=db.IntegerProperty()     # middle category
    categoryValue=db.StringProperty()   # category name

class Diagnosis(db.Expando):
    diagnosisID=db.IntegerProperty()
    lCategoryID=db.IntegerProperty()
    lCategoryName=db.StringProperty()
    diagnosis=db.TextProperty()
    oppositelCategory=db.StringProperty()
    oppositeCategoryID=db.IntegerProperty()
 
    
class Level(db.Expando):
    levelID=db.IntegerProperty()
    levelName=db.StringProperty()